/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package myservlets;

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
import javax.servlet.http.*;
import javax.servlet.RequestDispatcher;

/**
 *
 * @author Yasmani
 */
public class Star extends HttpServlet {

    /**
     * Processes requests for both HTTP
     * <code>GET</code> and
     * <code>POST</code> methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
            /*
             * TODO output your page here. You may use following sample code.
             */
            int rank= Integer.parseInt(request.getParameter("star1").trim());
           String seller=request.getParameter("user").trim();
             HttpSession session = request.getSession();
             String buyer=(String) session.getAttribute("username");
             String comment=request.getParameter("cc").trim();
            
           
           Connection con = null;
            String url = "jdbc:mysql://localhost:3306/ismi";
            String driver = "com.mysql.jdbc.Driver";
            String q1= "INSERT INTO ismi.rating(user_gname,user_wname,rating,comment) VALUES (?,?,?,?);";
          //  String q2= "select avg(rank) from table where buyer='"+q1+"';";
            try
            {
                Class.forName(driver);
                con = DriverManager.getConnection(url,"root","isaac16");
                PreparedStatement ps;
                ResultSet rs=null;
                Statement st =null;
                 try
                {
                  
                    ps = con.prepareStatement(q1);
                    ps.setString(1,buyer);
                    ps.setString(2,seller);
                    ps.setInt(3,rank);
                    ps.setString(4,comment);
                    
                  out.println(buyer);
                         out.println(seller);
                         out.println(rank);
                   int i = ps.executeUpdate();  
                   out.println("failed ");
                   if(i!=0)
                   {  
                        out.println("<br>Record has been inserted");  
                   }  
                    else
                   {  
                        out.println("failed to insert the data");  
                    }  
                     
                     response.sendRedirect("profile.jsp?user="+seller); 
                     //RequestDispatcher rd = request.getRequestDispatcher("profile.jsp?user="+seller);
                     //rd.forward(request, response);
                    }
                
            catch (SQLException s1)
               {
                   out.println(s1.getMessage());
                }
                // rs1.close();
         //   rs.close();
           // st.close();
            con.close();
            }
            catch (Exception e)
            {
                e.printStackTrace();
            }
           
        } finally {            
            out.close();
        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP
     * <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP
     * <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}
